KeyASCII

KeyASCII list, I often need that in my projects. List of ASCII codes 1 to 256

KeyAscii.zip

Posts per year-month

Create summary list If you have SQL table named Messages, with DateStamp ...

Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Resources.zip

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...